Overview

Dataset statistics

Number of variables21
Number of observations13540
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 MiB
Average record size in memory168.0 B

Variable types

NUM17
BOOL3
CAT1

Reproduction

Analysis started2020-08-03 17:43:11.959277
Analysis finished2020-08-03 17:44:02.648157
Duration50.69 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

symbol is highly correlated with df_indexHigh correlation
df_index is highly correlated with symbolHigh correlation
nbb is highly correlated with lastprice and 2 other fieldsHigh correlation
lastprice is highly correlated with nbb and 2 other fieldsHigh correlation
nbo is highly correlated with lastprice and 2 other fieldsHigh correlation
currentreferenceprice is highly correlated with lastprice and 2 other fieldsHigh correlation
week is highly correlated with quarter and 1 other fieldsHigh correlation
quarter is highly correlated with week and 1 other fieldsHigh correlation
month is highly correlated with quarter and 1 other fieldsHigh correlation
matched_to_unmatched is highly skewed (γ1 = 44.00783743) Skewed
pct_move_snapshot_to_close is highly skewed (γ1 = -38.47594513) Skewed
df_index has unique values Unique
nearindicativeprice has 3622 (26.8%) zeros Zeros
farindicativeprice has 7729 (57.1%) zeros Zeros
day has 1975 (14.6%) zeros Zeros
week has 1964 (14.5%) zeros Zeros
month has 1964 (14.5%) zeros Zeros

Variables

df_index
Real number (ℝ≥0)

HIGH CORRELATION
UNIQUE

Distinct count13540
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6824.6439438700145
Minimum0
Maximum13653
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:02.705289image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile679.95
Q13409.75
median6825.5
Q310238.25
95-th percentile12972.05
Maximum13653
Range13653
Interquartile range (IQR)6828.5

Descriptive statistics

Standard deviation3942.111345
Coefficient of variation (CV)0.5776288664
Kurtosis-1.199112826
Mean6824.643944
Median Absolute Deviation (MAD)3414.5
Skewness0.0005596608777
Sum92405679
Variance15540241.86
2020-08-03T10:44:02.812225image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
20471< 0.1%
 
26601< 0.1%
 
47591< 0.1%
 
68061< 0.1%
 
6611< 0.1%
 
27081< 0.1%
 
129471< 0.1%
 
88491< 0.1%
 
108961< 0.1%
 
47431< 0.1%
 
Other values (13530)1353099.9%
 
ValueCountFrequency (%) 
01< 0.1%
 
11< 0.1%
 
21< 0.1%
 
31< 0.1%
 
41< 0.1%
 
ValueCountFrequency (%) 
136531< 0.1%
 
136521< 0.1%
 
136511< 0.1%
 
136501< 0.1%
 
136491< 0.1%
 

symbol
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count993
Unique (%)7.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.49716573057130614
Minimum0.0
Maximum1.0
Zeros14
Zeros (%)0.1%
Memory size105.8 KiB
2020-08-03T10:44:02.929835image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.04838709677
Q10.2469758065
median0.4959677419
Q30.7469758065
95-th percentile0.9495967742
Maximum1
Range1
Interquartile range (IQR)0.5

Descriptive statistics

Standard deviation0.288779035
Coefficient of variation (CV)0.5808506445
Kurtosis-1.19821321
Mean0.4971657306
Median Absolute Deviation (MAD)0.25
Skewness0.009155092402
Sum6731.623992
Variance0.08339333107
2020-08-03T10:44:03.029352image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1633064516140.1%
 
0.9122983871140.1%
 
0.4868951613140.1%
 
0.2963709677140.1%
 
0.7066532258140.1%
 
0.591733871140.1%
 
0.6975806452140.1%
 
0.2096774194140.1%
 
0.7510080645140.1%
 
0.6199596774140.1%
 
Other values (983)1340099.0%
 
ValueCountFrequency (%) 
0140.1%
 
0.001008064516140.1%
 
0.002016129032140.1%
 
0.003024193548140.1%
 
0.004032258065140.1%
 
ValueCountFrequency (%) 
1140.1%
 
0.9989919355140.1%
 
0.997983871140.1%
 
0.9969758065140.1%
 
0.9959677419140.1%
 

currentvolume
Real number (ℝ≥0)

Distinct count13508
Unique (%)99.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.019859587586763282
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:03.141116image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.000987772694
Q10.003019574097
median0.007153717859
Q30.01761479611
95-th percentile0.07362790921
Maximum1
Range1
Interquartile range (IQR)0.01459522201

Descriptive statistics

Standard deviation0.04681279213
Coefficient of variation (CV)2.357188533
Kurtosis102.3919017
Mean0.01985958759
Median Absolute Deviation (MAD)0.005137799498
Skewness8.187461622
Sum268.8988159
Variance0.002191437507
2020-08-03T10:44:03.258986image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.0058023301232< 0.1%
 
0.0039889157162< 0.1%
 
0.00054065341582< 0.1%
 
0.0011888400242< 0.1%
 
0.00076913686952< 0.1%
 
0.0028505220562< 0.1%
 
0.0080943345482< 0.1%
 
0.0083660944772< 0.1%
 
0.0016918439652< 0.1%
 
0.0021160320812< 0.1%
 
Other values (13498)1352099.9%
 
ValueCountFrequency (%) 
01< 0.1%
 
3.259727526e-061< 0.1%
 
3.940413088e-061< 0.1%
 
5.583890563e-051< 0.1%
 
6.238861337e-051< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.97025007031< 0.1%
 
0.96470983431< 0.1%
 
0.95721515351< 0.1%
 
0.78418761391< 0.1%
 

lastprice
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count10184
Unique (%)75.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.05981215805634262
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:03.373837image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.00497621818
Q10.01934933758
median0.03943086941
Q30.07354196011
95-th percentile0.1755151367
Maximum1
Range1
Interquartile range (IQR)0.05419262253

Descriptive statistics

Standard deviation0.07229631377
Coefficient of variation (CV)1.20872271
Kurtosis39.75592151
Mean0.05981215806
Median Absolute Deviation (MAD)0.02443742217
Skewness4.788344496
Sum809.8566201
Variance0.005226756984
2020-08-03T10:44:03.478864image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.018433461946< 0.1%
 
0.022801967876< 0.1%
 
0.012391042526< 0.1%
 
0.049306958996< 0.1%
 
0.0055729070986< 0.1%
 
0.043770796336< 0.1%
 
0.02376548885< 0.1%
 
0.013534202955< 0.1%
 
0.037475248545< 0.1%
 
0.028362626825< 0.1%
 
Other values (10174)1348499.6%
 
ValueCountFrequency (%) 
01< 0.1%
 
4.082715823e-061< 0.1%
 
4.082715823e-051< 0.1%
 
4.490987405e-051< 0.1%
 
7.757160063e-052< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.99968154821< 0.1%
 
0.96077326641< 0.1%
 
0.96056096521< 0.1%
 
0.94905995471< 0.1%
 

nbb
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count8776
Unique (%)64.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.05980527851351773
Minimum0.0
Maximum1.0
Zeros2
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:03.589582image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.004973903242
Q10.01935815861
median0.03942284916
Q30.0735610027
95-th percentile0.1754600626
Maximum1
Range1
Interquartile range (IQR)0.0542028441

Descriptive statistics

Standard deviation0.07225162544
Coefficient of variation (CV)1.208114522
Kurtosis39.71749354
Mean0.05980527851
Median Absolute Deviation (MAD)0.02444273824
Skewness4.784211578
Sum809.7634711
Variance0.005220297379
2020-08-03T10:44:03.688152image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.0284246379580.1%
 
0.00151924789170.1%
 
0.0100221352870.1%
 
0.0123990231170.1%
 
0.0300582378470.1%
 
0.0322309256870.1%
 
0.028089749986< 0.1%
 
0.0069754714986< 0.1%
 
0.0030384957816< 0.1%
 
0.0068447835076< 0.1%
 
Other values (8766)1347399.5%
 
ValueCountFrequency (%) 
02< 0.1%
 
4.083999706e-052< 0.1%
 
8.167999412e-052< 0.1%
 
0.00028587997942< 0.1%
 
0.00035122397471< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.9996651121< 0.1%
 
0.96138169881< 0.1%
 
0.96080177081< 0.1%
 
0.94866412371< 0.1%
 

nbo
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count8815
Unique (%)65.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.05979713517544261
Minimum0.0
Maximum1.0
Zeros2
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:03.794258image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.00496923554
Q10.01933999217
median0.03940625408
Q30.0735450124
95-th percentile0.1753961842
Maximum1
Range1
Interquartile range (IQR)0.05420502024

Descriptive statistics

Standard deviation0.07231182245
Coefficient of variation (CV)1.209285733
Kurtosis39.88743264
Mean0.05979713518
Median Absolute Deviation (MAD)0.02442796057
Skewness4.795638201
Sum809.6532103
Variance0.005228999667
2020-08-03T10:44:03.893743image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.0223593158470.1%
 
0.00723821647770.1%
 
0.0015178221770.1%
 
0.00266026896570.1%
 
0.0165654785270.1%
 
0.0046187491846< 0.1%
 
0.017520237636< 0.1%
 
0.011555033296< 0.1%
 
0.024587087096< 0.1%
 
0.010012730126< 0.1%
 
Other values (8805)1347599.5%
 
ValueCountFrequency (%) 
02< 0.1%
 
4.080167124e-052< 0.1%
 
8.160334247e-052< 0.1%
 
0.00028561169872< 0.1%
 
0.00035089437261< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.99989391571< 0.1%
 
0.96158930671< 0.1%
 
0.96092831961< 0.1%
 
0.94916111761< 0.1%
 

imbside
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size105.8 KiB
0
6890
1
6650
ValueCountFrequency (%) 
0689050.9%
 
1665049.1%
 

imbalancesize
Real number (ℝ≥0)

Distinct count12293
Unique (%)90.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.011663628691065
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:04.005363image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3.287140012e-05
Q10.0004155223888
median0.002195222276
Q30.008418414509
95-th percentile0.04981041291
Maximum1
Range1
Interquartile range (IQR)0.00800289212

Descriptive statistics

Standard deviation0.03791591344
Coefficient of variation (CV)3.250781935
Kurtosis165.38995
Mean0.01166362869
Median Absolute Deviation (MAD)0.002085928149
Skewness10.70734698
Sum157.9255325
Variance0.001437616492
2020-08-03T10:44:04.114267image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
2.558832354e-0570.1%
 
4.765825259e-056< 0.1%
 
6.448257531e-056< 0.1%
 
4.714648612e-055< 0.1%
 
2.654788567e-055< 0.1%
 
6.908847355e-065< 0.1%
 
1.944712589e-055< 0.1%
 
1.867947618e-055< 0.1%
 
2.526846949e-055< 0.1%
 
2.597214839e-054< 0.1%
 
Other values (12283)1348799.6%
 
ValueCountFrequency (%) 
01< 0.1%
 
6.397080884e-081< 0.1%
 
1.279416177e-071< 0.1%
 
2.558832354e-071< 0.1%
 
3.83824853e-072< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.88427533551< 0.1%
 
0.73682658731< 0.1%
 
0.7051213111< 0.1%
 
0.68767947811< 0.1%
 

notional_imbalance
Real number (ℝ≥0)

Distinct count13534
Unique (%)> 99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.012332210797616754
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:04.246963image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2.494251128e-05
Q10.0003601479137
median0.002415329316
Q30.01003843476
95-th percentile0.05186883542
Maximum1
Range1
Interquartile range (IQR)0.00967828685

Descriptive statistics

Standard deviation0.0366713497
Coefficient of variation (CV)2.973623327
Kurtosis171.769173
Mean0.0123322108
Median Absolute Deviation (MAD)0.002337504728
Skewness10.45264749
Sum166.9781342
Variance0.001344787889
2020-08-03T10:44:04.349339image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.00024498791862< 0.1%
 
0.00011788807492< 0.1%
 
3.863093949e-062< 0.1%
 
3.661221337e-062< 0.1%
 
5.174481767e-072< 0.1%
 
7.219676666e-062< 0.1%
 
0.00096810316651< 0.1%
 
0.0093164971491< 0.1%
 
0.024029343861< 0.1%
 
0.0015866628741< 0.1%
 
Other values (13524)1352499.9%
 
ValueCountFrequency (%) 
01< 0.1%
 
1.019680931e-071< 0.1%
 
1.612889805e-071< 0.1%
 
1.636276982e-071< 0.1%
 
1.74826029e-071< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.86770014791< 0.1%
 
0.84751598211< 0.1%
 
0.8414876641< 0.1%
 
0.73110080121< 0.1%
 
Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size105.8 KiB
0
10086
1
3454
ValueCountFrequency (%) 
01008674.5%
 
1345425.5%
 

matchedsize
Real number (ℝ≥0)

Distinct count13345
Unique (%)98.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.013611987335605022
Minimum0.0
Maximum1.0
Zeros2
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:04.462138image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.0001130181893
Q10.0009973790092
median0.00384608804
Q30.01139567042
95-th percentile0.05630751941
Maximum1
Range1
Interquartile range (IQR)0.01039829141

Descriptive statistics

Standard deviation0.03623107537
Coefficient of variation (CV)2.661703577
Kurtosis154.472265
Mean0.01361198734
Median Absolute Deviation (MAD)0.003416598615
Skewness9.639695021
Sum184.3063085
Variance0.001312690823
2020-08-03T10:44:04.561495image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
5.902742752e-053< 0.1%
 
4.509603646e-053< 0.1%
 
2.825123662e-063< 0.1%
 
0.0083088476043< 0.1%
 
0.00018762352523< 0.1%
 
0.00043551046963< 0.1%
 
0.0014215669133< 0.1%
 
9.638968795e-053< 0.1%
 
8.014522689e-053< 0.1%
 
0.00063828372042< 0.1%
 
Other values (13335)1351199.8%
 
ValueCountFrequency (%) 
02< 0.1%
 
1.059421373e-062< 0.1%
 
1.200677556e-061< 0.1%
 
1.765702289e-061< 0.1%
 
2.524954273e-061< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.8208654771< 0.1%
 
0.81496515321< 0.1%
 
0.79065623541< 0.1%
 
0.76916484881< 0.1%
 

currentreferenceprice
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count9549
Unique (%)70.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.05979393352178623
Minimum0.0
Maximum1.0
Zeros2
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:04.679213image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.004974633999
Q10.01934591226
median0.03941423516
Q30.07350630375
95-th percentile0.1754547718
Maximum1
Range1
Interquartile range (IQR)0.05416039149

Descriptive statistics

Standard deviation0.07227989271
Coefficient of variation (CV)1.208816488
Kurtosis39.78450714
Mean0.05979393352
Median Absolute Deviation (MAD)0.0244313567
Skewness4.789966878
Sum809.6098599
Variance0.00522438289
2020-08-03T10:44:04.798576image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.0460995947270.1%
 
0.0418794104870.1%
 
0.0393734216< 0.1%
 
0.013529894336< 0.1%
 
0.032214617186< 0.1%
 
0.028810716176< 0.1%
 
0.030100443656< 0.1%
 
0.012387097836< 0.1%
 
0.023578340746< 0.1%
 
0.0040365205116< 0.1%
 
Other values (9539)1347899.5%
 
ValueCountFrequency (%) 
02< 0.1%
 
4.081416088e-051< 0.1%
 
4.489557697e-051< 0.1%
 
8.570973785e-052< 0.1%
 
0.00028569912621< 0.1%
 
ValueCountFrequency (%) 
12< 0.1%
 
0.96076942861< 0.1%
 
0.96040210111< 0.1%
 
0.94890067061< 0.1%
 
0.94782317671< 0.1%
 

nearindicativeprice
Real number (ℝ≥0)

ZEROS

Distinct count6924
Unique (%)51.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.009568577663112374
Minimum0.0
Maximum1.0
Zeros3622
Zeros (%)26.8%
Memory size105.8 KiB
2020-08-03T10:44:04.905289image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.003179003179
Q30.007403257403
95-th percentile0.02099332099
Maximum1
Range1
Interquartile range (IQR)0.007403257403

Descriptive statistics

Standard deviation0.04278040973
Coefficient of variation (CV)4.47092674
Kurtosis106.0789199
Mean0.009568577663
Median Absolute Deviation (MAD)0.003179003179
Skewness9.887576282
Sum129.5585416
Variance0.001830163457
2020-08-03T10:44:05.006599image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0362226.8%
 
0.42946742951280.9%
 
1.000001e-06990.7%
 
0.0022000022100.1%
 
0.004500004590.1%
 
0.003800003890.1%
 
0.001600001680.1%
 
0.004200004280.1%
 
0.00900000980.1%
 
0.005600005670.1%
 
Other values (6914)963271.1%
 
ValueCountFrequency (%) 
0362226.8%
 
1.000001e-06990.7%
 
5.000005e-066< 0.1%
 
0.000140000141< 0.1%
 
0.0001480001482< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.42946742951280.9%
 
0.12577612581< 0.1%
 
0.12550512551< 0.1%
 
0.11917011921< 0.1%
 

farindicativeprice
Real number (ℝ≥0)

ZEROS

Distinct count3802
Unique (%)28.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.02691208934803031
Minimum0.0
Maximum1.0
Zeros7729
Zeros (%)57.1%
Memory size105.8 KiB
2020-08-03T10:44:05.115683image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30.03538087829
95-th percentile0.1192665831
Maximum1
Range1
Interquartile range (IQR)0.03538087829

Descriptive statistics

Standard deviation0.05869892623
Coefficient of variation (CV)2.181135975
Kurtosis64.75311816
Mean0.02691208935
Median Absolute Deviation (MAD)0
Skewness6.098403884
Sum364.3896898
Variance0.00344556394
2020-08-03T10:44:05.218815image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0772957.1%
 
0.0246880259170.1%
 
0.0030165433596< 0.1%
 
0.04169974285< 0.1%
 
0.0085574572135< 0.1%
 
0.042676150265< 0.1%
 
0.0082161115175< 0.1%
 
0.043525545365< 0.1%
 
0.021893754175< 0.1%
 
0.038191026585< 0.1%
 
Other values (3792)576342.6%
 
ValueCountFrequency (%) 
0772957.1%
 
0.0011986790722< 0.1%
 
0.0014368272312< 0.1%
 
0.0016035309432< 0.1%
 
0.0016352840312< 0.1%
 
ValueCountFrequency (%) 
12< 0.1%
 
0.93638268822< 0.1%
 
0.92011716892< 0.1%
 
0.91371098341< 0.1%
 
0.86802622812< 0.1%
 

matched_to_unmatched
Real number (ℝ≥0)

SKEWED

Distinct count13521
Unique (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.0024916821086949435
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:05.331008image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile3.100366932e-05
Q10.0002054723263
median0.0007196214763
Q30.001924664085
95-th percentile0.007949038039
Maximum1
Range1
Interquartile range (IQR)0.001719191759

Descriptive statistics

Standard deviation0.01438305909
Coefficient of variation (CV)5.772429412
Kurtosis2623.700714
Mean0.002491682109
Median Absolute Deviation (MAD)0.0006067932662
Skewness44.00783743
Sum33.73737575
Variance0.0002068723888
2020-08-03T10:44:05.476021image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.00044556992452< 0.1%
 
0.00048051569632< 0.1%
 
0.0015028483132< 0.1%
 
0.0047366980592< 0.1%
 
0.01029652912< 0.1%
 
0.00014336377512< 0.1%
 
0.0068594227042< 0.1%
 
0.028077005182< 0.1%
 
0.0087286315232< 0.1%
 
5.327616842e-052< 0.1%
 
Other values (13511)1352099.9%
 
ValueCountFrequency (%) 
01< 0.1%
 
1.027465555e-071< 0.1%
 
1.474172835e-071< 0.1%
 
2.326045886e-071< 0.1%
 
3.859410318e-071< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.83032176211< 0.1%
 
0.40224608221< 0.1%
 
0.35490387381< 0.1%
 
0.30862268721< 0.1%
 

pct_move_snapshot_to_close
Real number (ℝ≥0)

SKEWED

Distinct count380
Unique (%)2.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.9254041390895239
Minimum0.0
Maximum1.0
Zeros1
Zeros (%)< 0.1%
Memory size105.8 KiB
2020-08-03T10:44:05.588636image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0.9191685912
Q10.9237875289
median0.9259754467
Q30.9280418135
95-th percentile0.9327823022
Maximum1
Range1
Interquartile range (IQR)0.004254284672

Descriptive statistics

Standard deviation0.02257738285
Coefficient of variation (CV)0.0243973221
Kurtosis1546.90537
Mean0.9254041391
Median Absolute Deviation (MAD)0.002187917832
Skewness-38.47594513
Sum12529.97204
Variance0.0005097382164
2020-08-03T10:44:05.686509image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.92646165075323.9%
 
0.92585389572361.7%
 
0.92573234472241.7%
 
0.92512458982201.6%
 
0.92621854872111.6%
 
0.92731250762101.6%
 
0.92682630362101.6%
 
0.92597544672091.5%
 
0.92609699772061.5%
 
0.92548924272041.5%
 
Other values (370)1107881.8%
 
ValueCountFrequency (%) 
01< 0.1%
 
0.00048620396261< 0.1%
 
0.0013370608971< 0.1%
 
0.0015801628781< 0.1%
 
0.026984319921< 0.1%
 
ValueCountFrequency (%) 
11< 0.1%
 
0.99501640941< 0.1%
 
0.96244074391< 0.1%
 
0.96171143791< 0.1%
 
0.96000972411< 0.1%
 

day
Real number (ℝ≥0)

ZEROS

Distinct count5
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.48601920236336776
Minimum0.0
Maximum1.0
Zeros1975
Zeros (%)14.6%
Memory size105.8 KiB
2020-08-03T10:44:05.820378image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.1
median0.7
Q30.8
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.7

Descriptive statistics

Standard deviation0.37651959
Coefficient of variation (CV)0.7747010573
Kurtosis-1.681960878
Mean0.4860192024
Median Absolute Deviation (MAD)0.3
Skewness-0.1152296116
Sum6580.7
Variance0.1417670016
2020-08-03T10:44:05.942438image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.7388728.7%
 
0.1382228.2%
 
0197514.6%
 
1196414.5%
 
0.8189214.0%
 
ValueCountFrequency (%) 
0197514.6%
 
0.1382228.2%
 
0.7388728.7%
 
0.8189214.0%
 
1196414.5%
 
ValueCountFrequency (%) 
1196414.5%
 
0.8189214.0%
 
0.7388728.7%
 
0.1382228.2%
 
0197514.6%
 

quarter
Categorical

HIGH CORRELATION

Distinct count3
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size105.8 KiB
0
5914
1
3840
0.5
3786
ValueCountFrequency (%) 
0591443.7%
 
1384028.4%
 
0.5378628.0%
 
2020-08-03T10:44:06.130566image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

year
Boolean

Distinct count2
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size105.8 KiB
0
7626
1
5914
ValueCountFrequency (%) 
0762656.3%
 
1591443.7%
 

week
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count7
Unique (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.44402027199103555
Minimum0.0
Maximum1.0
Zeros1964
Zeros (%)14.5%
Memory size105.8 KiB
2020-08-03T10:44:06.243156image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.1034482759
median0.4482758621
Q30.8965517241
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.7931034483

Descriptive statistics

Standard deviation0.3657195861
Coefficient of variation (CV)0.8236551553
Kurtosis-1.410765382
Mean0.444020272
Median Absolute Deviation (MAD)0.3448275862
Skewness0.3085576813
Sum6012.034483
Variance0.1337508156
2020-08-03T10:44:06.348713image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1379310345197514.6%
 
0.1034482759197514.6%
 
0196414.5%
 
1192814.2%
 
0.8965517241191214.1%
 
0.5517241379189414.0%
 
0.4482758621189214.0%
 
ValueCountFrequency (%) 
0196414.5%
 
0.1034482759197514.6%
 
0.1379310345197514.6%
 
0.4482758621189214.0%
 
0.5517241379189414.0%
 
ValueCountFrequency (%) 
1192814.2%
 
0.8965517241191214.1%
 
0.5517241379189414.0%
 
0.4482758621189214.0%
 
0.1379310345197514.6%
 

month
Real number (ℝ≥0)

HIGH CORRELATION
ZEROS

Distinct count6
Unique (%)< 0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.4449250896813674
Minimum0.0
Maximum1.0
Zeros1964
Zeros (%)14.5%
Memory size105.8 KiB
2020-08-03T10:44:06.456802image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.1428571429
median0.4285714286
Q30.8571428571
95-th percentile1
Maximum1
Range1
Interquartile range (IQR)0.7142857143

Descriptive statistics

Standard deviation0.3542395423
Coefficient of variation (CV)0.7961779422
Kurtosis-1.364953584
Mean0.4449250897
Median Absolute Deviation (MAD)0.2857142857
Skewness0.3084892935
Sum6024.285714
Variance0.1254856534
2020-08-03T10:44:06.571585image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
0.1428571429395029.2%
 
0196414.5%
 
1192814.2%
 
0.8571428571191214.1%
 
0.5714285714189414.0%
 
0.4285714286189214.0%
 
ValueCountFrequency (%) 
0196414.5%
 
0.1428571429395029.2%
 
0.4285714286189214.0%
 
0.5714285714189414.0%
 
0.8571428571191214.1%
 
ValueCountFrequency (%) 
1192814.2%
 
0.8571428571191214.1%
 
0.5714285714189414.0%
 
0.4285714286189214.0%
 
0.1428571429395029.2%
 

Interactions

2020-08-03T10:43:22.074709image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:22.248607image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:22.390425image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:22.541446image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:22.676901image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:22.803935image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:22.933830image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:23.065370image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:23.200590image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:23.351779image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:23.503005image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:23.668477image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:23.824249image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:23.974152image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:24.129911image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:24.281554image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:24.426829image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:24.599871image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:24.773716image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:24.923766image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:25.070349image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:25.213151image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:25.353146image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:25.497648image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:25.645450image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:25.799175image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:25.944833image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:26.060010image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:26.175481image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:26.304029image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:26.451381image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:26.591344image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:26.723494image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:26.871325image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:27.054911image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:27.217918image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:27.363399image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:27.509418image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:27.662973image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:27.811117image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:27.947352image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:28.085055image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:28.216422image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:28.335114image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:28.462481image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:28.580507image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:28.708726image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:28.831758image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:28.958218image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:29.077687image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:29.212027image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:29.350502image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:29.491734image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:29.619275image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:29.741890image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:29.864413image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:30.008098image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:30.151717image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:30.299324image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:30.441055image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:30.588071image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:30.727619image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:30.863866image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:31.004751image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:31.143890image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:31.274789image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:31.400588image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:31.523176image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:31.667493image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:31.807628image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:31.933523image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:32.059301image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:32.190523image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:32.304495image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:32.433355image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:32.580552image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:32.701175image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:32.837328image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:32.973644image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:33.111613image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:33.242827image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:33.355901image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:33.471538image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:33.585223image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:33.693077image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:33.808948image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:33.927558image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:34.045452image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:34.158604image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:34.269738image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:34.384993image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:34.502315image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:34.617491image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:34.736740image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:34.857052image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:34.998645image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:35.145272image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:35.279435image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:36.850787image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:36.986511image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:37.118132image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:37.233938image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:37.351131image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:37.482108image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:37.623827image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:37.764243image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:37.899425image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:38.020577image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:38.138966image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:38.255752image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:38.377399image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:38.498231image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:38.618759image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:38.734940image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:38.860452image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:38.983338image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:39.117460image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:39.281032image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:39.404739image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:39.535470image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:39.663421image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:39.786048image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:39.903493image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:40.024384image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:40.143177image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:40.261590image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:40.388908image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:40.509700image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:40.626737image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:40.752984image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:40.876225image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:41.013297image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:41.161607image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:41.297801image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:41.418457image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:41.544085image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:41.661895image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:41.784186image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:41.898283image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:42.022263image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:42.141977image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:42.264692image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:42.379936image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:42.500950image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:42.619212image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:42.736924image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:42.869357image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:43.005848image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:43.141658image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:43.274618image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:43.411453image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:43.544072image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:43.674432image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:43.804917image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:43.940948image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:44.070818image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:44.201329image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:44.334554image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:44.468375image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:44.609562image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:44.801192image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:44.937889image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:45.074463image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:45.445108image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:45.586455image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:45.709181image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:45.840474image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:45.970448image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:46.151922image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:46.286114image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:46.415379image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:46.574401image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:46.737677image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:46.870406image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:46.996169image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:47.124094image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:47.251254image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:47.367674image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:47.481879image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:47.610175image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:47.732691image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:47.856921image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:47.985191image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:48.113063image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:48.236604image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:48.360972image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:48.479088image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:48.610955image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:48.741306image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:48.869059image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:48.992122image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:49.117331image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:49.243316image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:49.364576image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:49.506342image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:49.654516image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:49.782965image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:49.908488image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:50.035485image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:50.155586image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:50.279052image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:50.401392image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:50.525970image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:50.657302image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:50.783739image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:50.919876image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:51.051623image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:51.173843image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:51.304185image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:51.420929image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:51.547989image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:51.675808image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:51.799956image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:51.913453image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:52.034355image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:52.162999image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:52.288608image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:52.412238image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:52.536254image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:52.659552image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:52.775688image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:52.913132image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:53.066134image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:53.200090image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:53.328078image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:53.453063image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:53.592578image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:53.721457image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:53.849221image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:53.974091image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:54.101635image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:54.231470image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:54.356342image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:54.473705image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:54.611574image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:54.753740image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:54.879810image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:54.996530image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:55.129226image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:55.252210image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:55.369832image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:55.486914image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:55.612294image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:55.999234image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:56.135659image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:56.251971image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:56.370951image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:56.493052image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:56.623359image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:56.744314image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:56.877831image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:57.042120image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:57.171708image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:57.300997image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:57.473510image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:57.604121image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:57.729174image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:57.855788image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:57.999840image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:58.120979image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:58.250493image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:58.376231image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:58.500864image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:58.627906image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:58.755594image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:58.876738image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:58.996130image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:59.113423image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:59.232002image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:59.355699image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:59.480896image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:59.596073image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:59.710618image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:59.836374image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:43:59.950835image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:00.081255image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:00.201961image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:00.325092image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:00.446727image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:00.567173image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:00.683313image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:00.803656image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:00.926363image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:01.056865image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:01.177033image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:01.295047image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:01.412165image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:01.538846image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:01.657493image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Correlations

2020-08-03T10:44:06.734637image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
2020-08-03T10:44:07.066449image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
2020-08-03T10:44:07.752322image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
2020-08-03T10:44:08.052321image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Missing values

2020-08-03T10:44:01.956523image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/
2020-08-03T10:44:02.408460image/svg+xmlMatplotlib v3.3.0, https://matplotlib.org/

Sample

First rows

df_indexsymbolcurrentvolumelastpricenbbnboimbsideimbalancesizenotional_imbalanceimbalancetypematchedsizecurrentreferencepricenearindicativepricefarindicativepricematched_to_unmatchedpct_move_snapshot_to_closedayquarteryearweekmonth
000.00.1342390.1745970.1746970.1745330.00.0007230.0033470.00.0053530.1745500.0216000.171800.0001510.9290140.70.01.00.1379310.142857
110.00.1366200.1746790.1747300.1745741.00.0013800.0063910.00.0070920.1746150.0215000.000000.0002180.9285280.70.01.00.1379310.142857
220.00.1072340.1787450.1787980.1786301.00.0012520.0059310.00.0358280.1786880.0220010.174650.0000390.9281630.00.01.00.1034480.142857
330.00.1103140.1787290.1787810.1786300.00.0088720.0420330.00.0375770.1786880.0221670.000000.0002640.9282850.00.01.00.1034480.142857
440.00.1949330.1666360.1666840.1665280.00.1496680.6614361.00.1090030.1665750.0000000.000000.0015360.9376441.00.01.00.0000000.000000
550.00.2082300.1674260.1674600.1673280.00.0978460.4344550.00.1546450.1673670.0215600.000000.0007080.9319311.00.01.00.0000000.000000
660.00.0933420.1725150.1725650.1724121.00.1896950.8677001.00.1211920.1724600.0000000.000000.0017520.9239090.11.00.01.0000001.000000
770.00.0965060.1723680.1724260.1722651.00.0904510.4133930.00.1714240.1723210.0212250.168180.0005900.9248810.11.00.01.0000001.000000
880.00.1461960.1569190.1569480.1568170.00.2035610.8475161.00.2404060.1568530.0000000.000000.0009470.9333900.71.00.00.8965520.857143
990.00.1579120.1570420.1570870.1569560.00.1079900.4499600.00.3023190.1570080.0194550.155090.0004000.9324180.71.00.00.8965520.857143

Last rows

df_indexsymbolcurrentvolumelastpricenbbnboimbsideimbalancesizenotional_imbalanceimbalancetypematchedsizecurrentreferencepricenearindicativepricefarindicativepricematched_to_unmatchedpct_move_snapshot_to_closedayquarteryearweekmonth
13530136441.00.1351750.0120770.0120800.0120691.00.1046790.0365021.00.0510500.0120690.0000000.0000000.0022950.9201411.00.01.00.0000000.000000
13531136451.00.1402460.0120850.0120890.0120771.00.0913460.0318730.00.0587550.0120850.0015950.0126140.0017400.9192901.00.01.00.0000000.000000
13532136461.00.0188480.0320170.0320270.0319971.00.0125410.0109591.00.0096960.0320110.0000000.0000000.0014470.9271910.11.00.01.0000001.000000
13533136471.00.0197700.0320040.0320190.0319891.00.0005450.0004760.00.0137370.0319940.0040460.0000000.0000440.9276770.11.00.01.0000001.000000
13534136481.00.0274880.0300900.0300990.0300711.00.0334320.0275181.00.0140300.0300800.0000000.0000000.0026670.9234230.71.00.00.8965520.857143
13535136491.00.0285180.0300320.0300420.0300141.00.0160850.0132160.00.0196630.0300270.0037470.0000000.0009150.9256110.71.00.00.8965520.857143
13536136501.00.0224420.0250800.0250840.0250601.00.0236290.0163321.00.0050680.0250640.0000000.0000000.0052170.9268260.10.50.00.5517240.571429
13537136511.00.0235760.0250800.0250920.0250691.00.0137450.0095010.00.0082320.0250800.0031550.0000000.0018680.9268260.10.50.00.5517240.571429
13538136521.00.0406160.0216670.0216620.0216410.00.0314070.0188841.00.0027300.0216480.0000000.0000000.0128730.9234230.80.50.00.4482760.428571
13539136531.00.0423830.0216510.0216620.0216410.00.0188410.0113210.00.0065480.0216440.0029340.0232910.0032200.9242740.80.50.00.4482760.428571